﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using nplJobsCommon.JobSeeker;
using nplJobs.DB;
using System.Data;
using nplJobsCommon;

namespace nplJobsDAL.Insert
{
    public class InsertAppliedJobs
    {
        public static int Insert(Int64 jobID, Guid JobSeekerID,float expectedAmount, DateTime AppliedDate)
        {
            object paramval = null;
            DBHelper db = new DBHelper();

            CustomParameterList cpList = new CustomParameterList();

            cpList.Add(new CustomParameter("@JobID", jobID, DbType.Int64));
            cpList.Add(new CustomParameter("@JobSeekerID", JobSeekerID, DbType.Guid));
            cpList.Add(new CustomParameter("@ExpectedSalary", expectedAmount, DbType.Decimal));
            cpList.Add(new CustomParameter("@AppliedDate", AppliedDate, DbType.DateTime));



            return db.ExecuteNonQuery(cpList.ParameterNames, cpList.ParameterValues, cpList.ParameterTypes, ref paramval, null, "spInsertAppliedJobs");
               
        }
    }
}
